BEGIN;

ALTER TABLE win_observations ADD COLUMN nativeness VARCHAR DEFAULT 'not known';
UPDATE win_observations SET nativeness = 'not known';
COMMENT ON COLUMN win_observations.basis_of_record IS 'Nativeness';

ALTER TABLE win_observations ADD COLUMN iucn_threat_category VARCHAR DEFAULT 'Not Evaluated (NE)';
UPDATE win_observations SET iucn_threat_category = 'Not Evaluated (NE)';
COMMENT ON COLUMN win_observations.basis_of_record IS 'IUCN Threat Category';

COMMIT;